package com.iafme.dto.res;

import cn.zhxu.bs.bean.DbField;
import cn.zhxu.bs.bean.SearchBean;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;

import java.io.Serializable;
import java.time.LocalDateTime;

/**
 * @author summer
 * @version 1.0
 * @date 2025/1/7 17:48
 */
@Data
@SearchBean(tables = " iafme_showings s  LEFT JOIN  iafme_project p ON s.projectId=p.id " +
        " LEFT JOIN iafme_level l ON l.id=s.levelId" , orderBy = "s.createTime DESC")
public class ShowingsResDTO implements Serializable {

    @DbField("s.id")
    private Integer id;

    @DbField("s.projectId")
    private Integer projectId;

    @DbField("s.levelId")
    private Integer levelId;

    @DbField("s.city")
    private String city;

    @DbField("s.name")
    private String name;

    @DbField("s.address")
    private String address;

    @DbField("s.createTime")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss",timezone = "GMT+8")
    private LocalDateTime createTime;

    @DbField("p.name")
    private String projectName;

    @DbField("l.name")
    private String levelName;


}
